package com.zkthink.ceres.applet.product.domain.entity;

import com.baomidou.mybatisplus.annotation.*;

import java.math.BigDecimal;
import java.util.Date;
import lombok.Data;

/**

@Author cmz
@Date 2024-04-30 13:02
*/
/**
    * 商品表
    */
@Data
@TableName(value = "applet_product")
public class AppletProduct {
    /**
     * 主键id
     */
    @TableId(value = "id", type = IdType.AUTO)
    private Long id;

    /**
     * 供应商
     */
    @TableField(value = "supplier_name")
    private String supplierName;

    /**
     * 商品类目ID.必须是叶子类目ID
     */
    @TableField(value = "category_id")
    private Long categoryId;

    /**
     * 分组id
     */
    @TableField(value = "group_id")
    private Long groupId;

    /**
     * 商品卖点
     */
    @TableField(value = "short_name")
    private String shortName;

    /**
     * 商品名称
     */
    @TableField(value = "product_name")
    private String productName;

    /**
     * 商品详情
     */
    @TableField(value = "sell_desc")
    private byte[] sellDesc;

    /**
     * 商品自编号
     */
    @TableField(value = "product_code")
    private String productCode;

    /**
     * 重量，单位：克
     */
    @TableField(value = "weight")
    private Long weight;

    /**
     * 总库存
     */
    @TableField(value = "stock")
    private Integer stock;

    /**
     * 总销量
     */
    @TableField(value = "sell_count")
    private Integer sellCount;

    /**
     * 需要物流：1-需要 0-不需要
     */
    @TableField(value = "need_logistics")
    private Integer needLogistics;

    /**
     * 允许超卖：1-允许 0-不允许
     */
    @TableField(value = "oversold")
    private Integer oversold;

    /**
     * 状态：1-上架 0-下架
     */
    @TableField(value = "status")
    private Integer status;

    /**
     * 款式类型：1-多款式 0-单款式
     */
    @TableField(value = "attr_style")
    private Integer attrStyle;

    @TableField(value = "sell_type")
    private String sellType;

    /**
     * 商品分类表id
     */
    @TableField(value = "product_category_id")
    private Integer productCategoryId;

    /**
     * 创建人
     */
    @TableField(value = "create_user")
    private String createUser;

    /**
     * 创建时间
     */
    @TableField(value = "create_time")
    private Date createTime;

    /**
     * 最后修改人
     */
    @TableField(value = "update_user")
    private String updateUser;

    /**
     * 最后修改时间
     */
    @TableField(value = "update_time")
    private Date updateTime;

    /**
     * 逻辑删除 1-删除 0-未删除
     */
    @TableField(value = "is_delete")
    @TableLogic(value = "0",delval = "1")
    private Integer isDelete;

    /**
     * 产品图片多张逗号间隔
     */
    @TableField(value = "product_img")
    private String productImg;

    /**
     * 背景图
     */
    @TableField(value = "background_img")
    private String backgroundImg;

    /**
     * 温馨提示
     */
    @TableField(value = "remarks")
    private String remarks;
    /**
     * 服务内容
     */
    @TableField(value = "content")
    private String content;

    /**
     * 门市价
     */
    @TableField(value = "store_price")
    private BigDecimal storePrice;

    @TableField(value = "original_price")
    private BigDecimal originalPrice;

    /**
     * 团购价
     */
    @TableField(value = "group_buy_price")
    private BigDecimal groupBuyPrice;

    /**
     * 归属
     */
    @TableField(value = "belong")
    private Integer belong;

    @TableField(value = "is_course")
    private Integer isCourse;

    @TableField(value = "is_recommend")
    private Integer isRecommend;

    public static final String COL_ID = "id";

    public static final String COL_SUPPLIER_NAME = "supplier_name";

    public static final String COL_CATEGORY_ID = "category_id";

    public static final String COL_GROUP_ID = "group_id";

    public static final String COL_SHORT_NAME = "short_name";

    public static final String COL_PRODUCT_NAME = "product_name";

    public static final String COL_SELL_DESC = "sell_desc";

    public static final String COL_PRODUCT_CODE = "product_code";

    public static final String COL_WEIGHT = "weight";

    public static final String COL_STOCK = "stock";

    public static final String COL_SELL_COUNT = "sell_count";

    public static final String COL_NEED_LOGISTICS = "need_logistics";

    public static final String COL_OVERSOLD = "oversold";

    public static final String COL_STATUS = "status";

    public static final String COL_ATTR_STYLE = "attr_style";

    public static final String COL_SELL_TYPE = "sell_type";

    public static final String COL_PRODUCT_CATEGORY_ID = "product_category_id";

    public static final String COL_CREATE_USER = "create_user";

    public static final String COL_CREATE_TIME = "create_time";

    public static final String COL_UPDATE_USER = "update_user";

    public static final String COL_UPDATE_TIME = "update_time";

    public static final String COL_IS_DELETE = "is_delete";
}